/*
MySQL Backup
Database: traffic_dev
Backup Time: 2018-12-14 11:35:16
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `traffic_dev`.`ta_accident`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_accident_image`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_accident_personnel`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_accident_police_log`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_accident_report`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_accident_report_assign`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_accident_vehicle`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_address`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_city`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_district`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_hms_push`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_onduty_accident`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_onduty_mobile`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_police`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_session`;
DROP TABLE IF EXISTS `traffic_dev`.`ta_street`;
CREATE TABLE `ta_accident` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `district_id` int(11) DEFAULT NULL COMMENT '行政区域id',
  `street_id` int(11) DEFAULT NULL COMMENT '路段id',
  `address_id` int(11) DEFAULT NULL COMMENT '地址id',
  `amap_latitude` double(22,18) DEFAULT NULL COMMENT '维度',
  `amap_longitude` double(22,18) DEFAULT NULL COMMENT '经度',
  `amap_address` varchar(255) DEFAULT NULL COMMENT '详细地址',
  `amap_district` varchar(255) DEFAULT NULL,
  `amap_street` varchar(255) DEFAULT NULL,
  `location_id_list` varchar(255) DEFAULT NULL,
  `geojson_list` text,
  `state` int(1) DEFAULT NULL COMMENT '案件状态：1 指挥中心已接警，未通知值班警官 2 已通知值班警官 3 已勘察已上报 4已结案 ',
  `occur_time` timestamp NULL DEFAULT NULL COMMENT '发生时间',
  `police_report_time` timestamp NULL DEFAULT NULL COMMENT '上报时间',
  `type` int(2) DEFAULT NULL COMMENT '事故类型：1车损 2商人 3死亡 4其他',
  `deal_type` int(2) DEFAULT NULL COMMENT '处理类型 1受理 2快赔 3自行协商 4 微信快速处理 5其他',
  `paper_number` varchar(50) DEFAULT NULL COMMENT '事故认证书编号(app无关)',
  `paper_accident_process` text COMMENT '事故发生经过(app无关)',
  `paper_accident_reason` text COMMENT '事故原因(app无关)',
  `paper_personnel_responsibility` varchar(255) DEFAULT NULL COMMENT '当事人责任或意外原因(app无关)',
  `paper_image_base64` text,
  `paper_time` timestamp NULL DEFAULT NULL COMMENT '责任认定书出具时间(app无关)',
  `pavement_story` varchar(255) DEFAULT NULL COMMENT '路面状况(,隔开)',
  `wounded_amount` int(11) DEFAULT NULL COMMENT '受伤人数 ',
  `death_amount` int(11) DEFAULT NULL COMMENT '死亡人数',
  `add_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='事故';
CREATE TABLE `ta_accident_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accident_id` int(11) DEFAULT NULL,
  `image_base64` longblob,
  `add_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='事故图片';
CREATE TABLE `ta_accident_personnel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accident_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL COMMENT '姓名',
  `address` varchar(20) DEFAULT NULL COMMENT '地址',
  `driving_license_number` varchar(20) DEFAULT NULL COMMENT '驾照号码',
  `id_card_number` varchar(20) DEFAULT NULL COMMENT '身份证号码',
  `plate_number` varchar(10) DEFAULT NULL COMMENT '车牌号码',
  `allow_type` varchar(64) DEFAULT NULL COMMENT '准驾车型',
  `vehicle_type` varchar(64) DEFAULT NULL,
  `transport_type` int(1) DEFAULT NULL COMMENT '交通方式：1驾车，2步行',
  `from_direction` varchar(5) DEFAULT NULL COMMENT '来向',
  `toward_direction` varchar(5) DEFAULT NULL COMMENT '去向',
  `liability_ratio` int(10) DEFAULT NULL COMMENT '责任比例',
  `law_name` varchar(255) DEFAULT NULL COMMENT '法律名称',
  `law_article` varchar(255) DEFAULT NULL COMMENT 'XX条',
  `law_paragraph` varchar(255) DEFAULT NULL COMMENT 'XX款',
  `law_subparagraph` varchar(255) DEFAULT NULL COMMENT 'XX项',
  `is_operate` int(1) DEFAULT NULL COMMENT '是否为运营0:否1是',
  `add_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='事故当事人（来源于认定书，与app无关）';
CREATE TABLE `ta_accident_police_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(3) DEFAULT NULL COMMENT '1:拒绝案件2:同意案件',
  `report_id` int(11) DEFAULT NULL,
  `police_number` varchar(15) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL COMMENT '类容',
  `other` varchar(255) DEFAULT NULL COMMENT '说明',
  `add_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='事故处理日志';
CREATE TABLE `ta_accident_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accept_personnel` varchar(15) DEFAULT NULL COMMENT '接警人',
  `accept_party` varchar(15) DEFAULT NULL COMMENT '接警单位：xx大队',
  `accept_time` timestamp NULL DEFAULT NULL COMMENT '接警时间',
  `accident_id` int(11) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL COMMENT '警情案由',
  `type` int(1) DEFAULT NULL COMMENT '报警方式：1 电话报警',
  `address` varchar(50) DEFAULT NULL COMMENT '报警地址',
  `contact_name` varchar(15) DEFAULT NULL COMMENT '报警人姓名',
  `contact_cell_number` varchar(15) DEFAULT NULL COMMENT '报警人电话号码',
  `is_accident_personnel` int(1) DEFAULT NULL COMMENT '报警人是否是当事人 0 否 1 是',
  `content` varchar(255) DEFAULT NULL COMMENT '报警内容',
  `plate_number_list` varchar(255) DEFAULT NULL COMMENT '车牌号码列表',
  `add_time` timestamp NULL DEFAULT NULL,
  `jjdbh` varchar(50) DEFAULT NULL COMMENT '接警单编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='事故报警记录';
CREATE TABLE `ta_accident_report_assign` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accident_report_id` int(11) DEFAULT NULL,
  `assigned_police_number` varchar(15) DEFAULT NULL COMMENT '分派去勘察的警员编号',
  `assigned_police_accept_time` timestamp NULL DEFAULT NULL,
  `has_accepted` int(1) DEFAULT NULL COMMENT '是否已经接受任务0 拒绝 1接受 2待同意 3失效 4转发',
  `add_time` timestamp NULL DEFAULT NULL,
  `assign_all` int(1) DEFAULT NULL,
  `report_source` int(1) DEFAULT '1' COMMENT '1:正常 2:转发(未完成) 3:转发(完成)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='事故报警记录';
CREATE TABLE `ta_accident_vehicle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `accident_id` int(11) DEFAULT NULL,
  `plate_number` varchar(10) DEFAULT NULL COMMENT '车牌号码（来源于图像识别或责任认定书）',
  `source` int(10) DEFAULT NULL COMMENT '信息来源：1 现场勘察图片 2 认定书',
  `serial` varchar(20) DEFAULT NULL COMMENT '车辆系列（来自图像识别）',
  `brand` varchar(20) DEFAULT NULL COMMENT '车辆品牌（来自图像识别）',
  `type` varchar(20) DEFAULT NULL COMMENT '车型（来自图像识别或责任认定书）',
  `color` varchar(20) DEFAULT NULL COMMENT '车辆颜色（来自图像识别）',
  `youtu_idx` varchar(255) DEFAULT NULL COMMENT '腾讯优图给出的汽车id',
  `youtu_confidence` float DEFAULT NULL COMMENT '识别准确度',
  `add_time` timestamp NULL DEFAULT NULL,
  `is_commercial` int(1) DEFAULT NULL COMMENT '是否为营运车辆，0 否 1 是',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='事故相关车辆（来源于勘察现场和认定书图片的识别结果）';
CREATE TABLE `ta_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `street_id` int(11) DEFAULT NULL COMMENT '所属街道id',
  `name` varchar(100) DEFAULT NULL COMMENT '地址（唯一）',
  `add_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='地址';
CREATE TABLE `ta_city` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL COMMENT '城市名称',
  `add_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='城市表';
CREATE TABLE `ta_district` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL COMMENT '行政区名称',
  `add_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='行政区域';
CREATE TABLE `ta_hms_push` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `police_number` varchar(15) DEFAULT NULL,
  `is_success` bit(1) NOT NULL COMMENT '是否推送成功',
  `send_content` varchar(255) DEFAULT NULL COMMENT '推送内容',
  `send_time` timestamp NULL DEFAULT NULL COMMENT '推送时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='推送记录';
CREATE TABLE `ta_onduty_accident` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `attended_date` varchar(10) DEFAULT NULL COMMENT '2018-12-10',
  `police_number` varchar(15) DEFAULT NULL,
  `add_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='事故中队值班表';
CREATE TABLE `ta_onduty_mobile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `attended_date` varchar(10) DEFAULT NULL COMMENT '2018-12-10',
  `police_number` varchar(15) DEFAULT NULL,
  `add_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='机动中队值班表';
CREATE TABLE `ta_police` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `police_number` varchar(15) DEFAULT NULL COMMENT '警员编号',
  `name` varchar(100) DEFAULT NULL COMMENT '警员姓名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `add_time` timestamp NULL DEFAULT NULL,
  `level` int(2) DEFAULT NULL COMMENT '1:警员 2:队长 3:接警员',
  `type` int(1) DEFAULT NULL COMMENT '0:默认 1:事故中队 2:机动中队',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
CREATE TABLE `ta_session` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `police_number` varchar(15) DEFAULT NULL,
  `type` int(1) DEFAULT NULL COMMENT '类型：1 app 2 管理后台',
  `session_key` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='登录session';
CREATE TABLE `ta_street` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `district_id` int(11) DEFAULT NULL COMMENT '所属行政区域id',
  `name` varchar(100) DEFAULT NULL COMMENT '路段名称',
  `add_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='街道';
BEGIN;
LOCK TABLES `traffic_dev`.`ta_accident` WRITE;
DELETE FROM `traffic_dev`.`ta_accident`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_accident_image` WRITE;
DELETE FROM `traffic_dev`.`ta_accident_image`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_accident_personnel` WRITE;
DELETE FROM `traffic_dev`.`ta_accident_personnel`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_accident_police_log` WRITE;
DELETE FROM `traffic_dev`.`ta_accident_police_log`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_accident_report` WRITE;
DELETE FROM `traffic_dev`.`ta_accident_report`;
INSERT INTO `traffic_dev`.`ta_accident_report` (`id`,`accept_personnel`,`accept_party`,`accept_time`,`accident_id`,`description`,`type`,`address`,`contact_name`,`contact_cell_number`,`is_accident_personnel`,`content`,`plate_number_list`,`add_time`,`jjdbh`) VALUES (1, '冉凯', 'XX大队', '2018-11-09 15:46:43', -1, '两车相撞', 1, '莲湖区枣园西路', '小马1', '18710723006', 1, '两车出租车相撞', '陕A110,陕A111', '2018-12-09 16:38:47', NULL),(2, '冉凯', 'XX大队', '2018-11-09 15:46:43', -1, '两车相撞', 1, '莲湖区枣园西路', '小马2', '18710723006', 1, '两车出租车相撞', '陕A110,陕A111', '2018-12-09 20:57:04', NULL),(3, '冉凯', 'XX大队', '2018-11-09 15:46:43', -1, '两车相撞', 1, '莲湖区枣园西路', '小马3', '18710723006', 1, '两车出租车相撞', '陕A110,陕A111', '2018-12-09 16:38:47', NULL),(4, '冉凯', 'XX大队', '2018-11-09 15:46:43', -1, '两车相撞', 1, '莲湖区枣园西路', '小马4', '18710723006', 1, '两车出租车相撞', '陕A110,陕A111', '2018-12-09 20:57:04', NULL),(5, '冉凯', 'XX大队', '2018-11-09 15:46:43', -1, '两车相撞', 1, '莲湖区枣园西路', '小马5', '18710723006', 1, '两车出租车相撞', '陕A110,陕A111', '2018-12-09 16:38:47', NULL),(6, '冉凯', 'XX大队', '2018-11-09 15:46:43', -1, '两车相撞', 1, '莲湖区枣园西路', '小马6', '18710723006', 1, '两车出租车相撞', '陕A110,陕A111', '2018-12-09 20:57:04', NULL),(7, '冉凯', 'XX大队', '2018-11-09 15:46:43', -1, '两车相撞', 1, '莲湖区枣园西路', '小马7', '18710723006', 1, '两车出租车相撞', '陕A110,陕A111', '2018-12-09 16:38:47', NULL),(8, '冉凯', 'XX大队', '2018-11-09 15:46:43', -1, '两车相撞', 1, '莲湖区枣园西路', '小马8', '18710723006', 1, '两车出租车相撞', '陕A110,陕A111', '2018-12-09 20:57:04', NULL),(9, '冉凯', 'XX大队', '2018-11-09 15:46:43', -1, '两车相撞', 1, '莲湖区枣园西路', '小马9', '18710723006', 1, '两车出租车相撞', '陕A110,陕A111', '2018-12-09 16:38:47', NULL),(10, '冉凯', 'XX大队', '2018-11-09 15:46:43', -1, '两车相撞', 1, '莲湖区枣园西路', '小马10', '18710723006', 1, '两车出租车相撞', '陕A110,陕A111', '2018-12-09 20:57:04', '20181013105314953002'),(11, '李文轩', '西安交警支队', '2018-11-13 10:53:14', 3, '咨询挪车', 1, '外地车 挪车', '匿名', '17792818592', 0, '挪车', 'None', '2018-12-11 14:59:00', '20181113105314953002'),(12, '临潼交警大队', '临潼交警大队', '2018-11-13 10:53:54', 4, '咨询', 1, 'None', '匿名', '83819060', 0, '公众号', '陕A', '2018-12-11 14:59:00', '20181113105354100067'),(13, '胡静', '西安交警支队', '2018-11-13 10:50:23', 5, '咨询部室电话', 1, '聂冯 包茂高速北', '匿名', '15389162908', 1, '坏车', 'None', '2018-12-11 14:59:00', '20181113105023035009'),(14, '白芳君', '西安交警支队', '2018-11-13 10:54:35', 6, '机动车擦剐', 1, '咨询已报事故', '匿名', '17006698809', 0, '对快赔处理结果有异议', 'None', '2018-12-11 14:59:00', '20181113105435648001'),(15, '朱琳', '碑林大队', '2018-11-13 10:52:13', 7, '非机动车和非机动车', 1, '水文巷农堪院门口', '110转警', '17691165585', 0, '上述地三轮车和电动车剐蹭，不要救护车。', 'None', '2018-12-11 14:59:00', '20181113105129356008'),(16, '王勐迁', '西安交警支队', '2018-11-13 10:54:53', 8, '机动车擦剐', 1, '凤城2路未央路十字西200M', '匿名', '15353590636', 0, '上述地址发生两车相碰事故', '陕AU9360   陕A85JY1', '2018-12-11 14:59:00', '20181113105453070003'),(17, '白芳君', '西安交警支队', '2018-11-13 10:55:41', -1, '咨询挪车', 1, '挪车', '匿名', '18691568837', 0, '咨询', '陕A', '2018-12-11 14:59:00', '20181113105541700001'),(18, '刘欢', '西安交警支队', '2018-11-13 10:53:53', -1, '咨询部室电话', 1, '11月12 建材路凤城一路  报过警 ', '匿名', '13572284583', 1, '联系民警 ', 'None', '2018-12-11 14:59:00', '20181113105353751011'),(19, '王勐迁', '西安交警支队', '2018-11-13 10:57:06', -1, '咨询', 1, '无人应答', '匿名', '18792961980', 0, 'None', '陕A', '2018-12-11 14:59:00', '20181113105706593003'),(20, '白芳君', '西安交警支队', '2018-11-13 10:56:38', -1, '其它', 1, '北二环以南 明光路 朱宏路之间', '匿名', '13359293840', 0, '违法拖移', '陕A03W78', '2018-12-11 14:59:00', '20181113105638782001'),(21, '白芳君', '西安交警支队', '2018-11-18 10:56:38', -1, '机动车刮擦', 1, '（测试0）北二环以南 明光路 朱宏路之间', '（测试0）匿名', '13359293840', 0, '违法拖移', '陕A03W78', '2018-12-11 14:59:00', '20181118105638782001'),(22, '白芳君', '西安交警支队', '2018-11-18 13:56:38', -1, '机动车刮擦', 1, '（测试1）北二环以南 明光路 朱宏路之间', '（测试1）匿名', '13359293840', 0, '违法拖移', '陕A03W78', '2018-12-11 14:59:00', '20181118135638782001'),(23, '白芳君', '西安交警支队', '2018-11-18 14:56:38', -1, '机动车刮擦', 1, '（测试2）北二环以南 明光路 朱宏路之间', '（测试2）匿名', '13359293840', 0, '违法拖移', '陕A03W78', '2018-12-11 14:59:00', '20181118145638782001'),(24, '王勐迁', '西安交警支队', '2018-11-19 10:54:53', -1, '机动车擦剐', 1, '凤城2路未央路十字西200M（测试4）', '（测试4）匿名', '15353590636', 0, '上述地址发生两车相碰事故（测试4）', '陕AU9360   陕A85JY1', '2018-12-11 14:59:00', '20181119105453070003'),(25, '王勐迁', '西安交警支队', '2018-11-19 11:54:53', -1, '机动车擦剐', 1, '凤城2路未央路十字西200M（测试5）', '（测试5）匿名', '15353590636', 0, '上述地址发生两车相碰事故（测试5）', '陕AU9360   陕A85JY1', '2018-12-11 14:59:00', '20181119115453070003'),(26, '王勐迁', '西安交警支队', '2018-11-20 11:54:53', -1, '机动车擦剐', 1, '凤城2路未央路十字西200M（测试6）', '（测试6）匿名', '15353590636', 0, '上述地址发生两车相碰事故（测试6）', '陕AU9360   陕A85JY1', '2018-12-11 14:59:00', '20181120115453070003');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_accident_report_assign` WRITE;
DELETE FROM `traffic_dev`.`ta_accident_report_assign`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_accident_vehicle` WRITE;
DELETE FROM `traffic_dev`.`ta_accident_vehicle`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_address` WRITE;
DELETE FROM `traffic_dev`.`ta_address`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_city` WRITE;
DELETE FROM `traffic_dev`.`ta_city`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_district` WRITE;
DELETE FROM `traffic_dev`.`ta_district`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_hms_push` WRITE;
DELETE FROM `traffic_dev`.`ta_hms_push`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_onduty_accident` WRITE;
DELETE FROM `traffic_dev`.`ta_onduty_accident`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_onduty_mobile` WRITE;
DELETE FROM `traffic_dev`.`ta_onduty_mobile`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_police` WRITE;
DELETE FROM `traffic_dev`.`ta_police`;
INSERT INTO `traffic_dev`.`ta_police` (`id`,`police_number`,`name`,`password`,`add_time`,`level`,`type`) VALUES (2, '100000', '队长', '0ef9a3183ece9d30c3dc5122a7bc9fef', '2018-11-05 17:15:17', 2, 0),(15, '100001', '测试警员1', '0ef9a3183ece9d30c3dc5122a7bc9fef', '2018-11-05 17:15:19', 1, 1),(16, '100002', '测试警员2', '0ef9a3183ece9d30c3dc5122a7bc9fef', '2018-11-05 17:15:21', 1, 2),(17, '100003', '测试警员3', '0ef9a3183ece9d30c3dc5122a7bc9fef', '2018-11-05 17:15:24', 3, 0);
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_session` WRITE;
DELETE FROM `traffic_dev`.`ta_session`;
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `traffic_dev`.`ta_street` WRITE;
DELETE FROM `traffic_dev`.`ta_street`;
UNLOCK TABLES;
COMMIT;
